package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "c_shop", simpleName = "", engine = MysqlDriver.InnoDB, comment = "")
public class _DDL_CShop {

    @_DDL_Primary()
    @_DDL_Column(name = "id", type = SqlType.INT_UNSIGNED, nullable = false, comment = "id")
    private Long id;

    @_DDL_Unique(name = "UNI_C_SHOP_CODE")
    @_DDL_Column(name = "code", type = SqlType.VARCHAR, size = 32, comment = "二维码")
    private String code;

    @_DDL_Column(name = "mer_id", type = SqlType.BIGINT_UNSIGNED, comment = "商户id")
    private java.math.BigInteger merId;

    @_DDL_Column(name = "name", type = SqlType.VARCHAR, size = 200, comment = "名称")
    private String name;

    @_DDL_Column(name = "address", type = SqlType.VARCHAR, size = 300, comment = "地址")
    private String address;

    @_DDL_Column(name = "concat_name", type = SqlType.VARCHAR, size = 30, comment = "联系人名称")
    private String concatName;

    @_DDL_Column(name = "phone", type = SqlType.VARCHAR, size = 20, comment = "联系人手机号码")
    private String phone;

    @_DDL_Column(name = "pwd", type = SqlType.VARCHAR, size = 32, comment = "密码")
    private String pwd;

    @_DDL_Unique(name = "UNI_C_SHOP_REFRESH_TOKEN")
    @_DDL_Column(name = "refresh_token", type = SqlType.VARCHAR, size = 32, comment = "")
    private String refreshToken;

    @_DDL_Column(name = "state", type = SqlType.TINYINT_UNSIGNED, comment = "状态0: 正常 1：关闭")
    private Integer state;

    @_DDL_Column(name = "cr_time", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP, comment = "创建时间")
    private java.sql.Timestamp crTime;

    @_DDL_Column(name = "properties", type = SqlType.MEDIUMTEXT, comment = "规则属性")
    private String properties;

    @_DDL_Column(name = "rules", type = SqlType.MEDIUMTEXT, comment = "规则")
    private String rules;

    @_DDL_Column(name = "login_time", type = SqlType.TIMESTAMP, comment = "登录时间")
    private java.sql.Timestamp loginTime;

}
